Printing a Collections Report

Once you have entered all of the required information needed to generate a collections report, command options will appear allowing you to print or choose from a set of other print options.

Note: The report will only include item details for customers that are either past due or over their credit limit.

If the report is run by sales rep the report will be sorted by sales rep, then customer, with a sub-total by sales rep and a grand total for all sales reps selected.

• Bill Cust - The bill-to customer ID.
• Customer Name - The name of the bill-to customer.
• Contact/Phone - The credit contact person and phone number of the customer.
• Ship Cust - The ship-to code.
• Cust PO - The customer's purchase order number.
• Order - The number assigned to the order.
• Invoice - The transaction reference number.
• Type - The transaction type.
• Transaction types are:
  • IN - Invoice
  • CR - Credit Invoice
  • CM - Credit Memo
  • DM - Debit Memo
  • CA - Cash Application
  • FC - Finance Charge
• Invoice Date - The date of the transaction
• Terms - The customer's credit terms.
• Original Inv Amt - The original amount of the transaction.
• Paid Amount - The amount paid.
• Open Amount - The open or unpaid balance on the transaction.
• Days Outstanding - The number of days the invoice is outstanding.
• Total Past Due - The total amount of the open transactions that are past due.
• CR Limit/Bal - The credit available for the customer and the current open balance.

Note: Credit hold warning appears if the customer is on permanent credit hold.

Totals for all past due customers appear at the bottom of the report for original invoice amount, paid amount, and open amount.

For more information on the Collections Report option see Collections Report.

Security Required : Receivables - Credit Management